{"text_format":"2","workbook":"xls","n_sheets":4,"sheets":["Residential","General Service Less Than 50 kW","Sentinel Lighting","Street Lighting"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":2,"defined_names":8,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Residential","index":0,"n_rows":119,"n_cols":12,"rows_kept":119,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
{"$rows_empty":19}
[null,null,"Residential"]
[]
[null,null,"Monthly Rates and Charges","Metric","Current Rate","Applied For Rate"]
[null,null,"Service Charge","$",8.45,13.78]
[null,null,"Service Charge Rate Rider(s)","$",0,0]
[null,null,"Distribution Volumetric Rate","$/kWh",0.008,0.0135]
[null,null,"Distribution Volumetric Rate Rider(s)","$/kWh",0,0.0193]
[null,null,"Retail Transmission Rate – Network Service Rate","$/kWh",0.0057,0.0057]
[null,null,"Retail Transmission Rate – Line and Transformation Connection Service Rate","$/kWh",0.005,0.005]
[null,null,"Wholesale Market Service Rate ","$/kWh",0.005200000014156103,0.0052]
[null,null,"Rural Rate Protection Charge","$/kWh",0.0010000000474974513,0.0013]
[null,null,"Standard Supply Service – Administration Charge (if applicable)","$",0.25,0.25]
[]
[null,null,"Consumption",1000,"kWh",0,"kW",null,"Current Loss Factor",1.0662]
[null,null,"RPP Tier One",600,"kWh","Load Factor","",null,"Proposed Loss Factor",1.0662]
[]
[null,null,null,"Volume","RATE                             $","CHARGE\n$","Volume","RATE                             $","CHARGE\n$","$","%","% of Total Bill"]
[null,null,"Energy First Tier (kWh)",600,0.05,30,600,0.05,30,0,0,0.22021581149526534]
[null,null,"Energy Second Tier (kWh)",467,0.059,27.55,467,0.059,27.55,0,0,0.202231520223152]
[null,null,"Sub-Total:  Energy",null,null,57.55,null,null,57.55,0,0,0.4224473317184173]
[null,null,"Service Charge",1,8.45,8.45,1,13.78,13.78,5.33,0.6307692307692309,0.1011524627468252]
[null,null,"Service Charge Rate Rider(s)",1,0,0,1,0,0,0,0,0]
[null,null,"Distribution Volumetric Rate",1000,0.008,8,1000,0.0135,13.5,5.5,0.6875,0.0990971151728694]
[null,null,"Distribution Volumetric Rate Rider(s)",1000,0,0,1000,0.0193,19.3,19.3,0,0.14167217206195404]
[null,null,"Total:  Distribution",null,null,16.45,null,null,46.58,30.130000000000003,1.8316109422492404,0.34192174998164865]
[null,null,"Retail Transmission Rate – Network Service Rate",1067,0.0057,6.08,1067,0.0057,6.08,0,0,0.04463040446304044]
[null,null,"Retail Transmission Rate – Line and Transformation Connection Service Rate",1067,0.005,5.34,1067,0.005,5.34,0,0,0.03919841444615723]
[null,null,"Total:    Retail Transmission",null,null,11.42,null,null,11.42,0,0,0.08382881890919767]
[null,null,"Sub-Total:  Delivery (Distribution and Retail Transmission)",null,null,27.869999999999997,null,null,58,30.130000000000003,1.0810907786149984,0.4257505688908463]
[null,null,"Wholesale Market Service Rate ",1067,0.0052,5.55,1067,0.0052,5.55,0,0,0.04073992512662408]
[null,null,"Rural Rate Protection Charge",1067,0.001,1.07,1067,0.0013,1.39,0.31999999999999984,0.2990654205607475,0.010203332599280626]
[null,null,"Standard Supply Service – Administration Charge (if applicable)",1,0.25,0.25,1,0.25,0.25,0,0,0.0018351317624605444]
[null,null,"Sub-Total:  Regulatory",null,null,6.87,null,null,7.1899999999999995,0.31999999999999984,0.046579330422125156,0.05277838948836525]
[null,null,"Debt Retirement Charge (DRC)",1000,0.00700000021606684,7,1000,0.00700000021606684,7,0,0,0.05138368934889524]
[null,null,"Total Bill before Taxes",null,null,99.28999999999999,null,null,129.74,30.450000000000017,0.30667740960821854,0.9523599794465242]
[null,null,"GST",99.29,0.05,4.96,129.74,0.05,6.49,1.5300000000000002,0.30846774193548393,0.047640020553475736]
[{"$nulls":5},104.24999999999999,null,null,136.23000000000002,31.980000000000032,0.3067625899280579,1]
[]
[]
[]
[null,null,"Rate Class Threshold Test"]
[null,null,"Residential"]
[null,null,"kWh",250,600,1000,1600,2250]
[null,null,"Loss Factor Adjusted kWh",267,640,1067,1706,2399]
[null,null,"kW"]
[null,null,"Load Factor","","","","",""]
[]
[null,null,"Energy"]
[null,null,"Applied For Bill",13.35,32.36,57.55,95.25,136.14]
[null,null,"Current Bill",13.35,32.36,57.55,95.25,136.14]
[null,null,"$ Impact",0,0,0,0,0]
[null,null,"% Impact",0,0,0,0,0]
[null,null,"% of Total Bill",0.3032023620258914,0.379189125849543,0.4224783438555278,0.44840410507485173,0.4614445988543538]
[]
[null,null,"Distribution"]
[null,null,"Applied For Bill",21.99,33.46,46.58,66.26,87.59]
[null,null,"Current Bill",10.45,13.25,16.45,21.25,26.45]
[null,null,"$ Impact",11.54,20.21,30.13,45.010000000000005,61.14]
[null,null,"% Impact",1.1043062200956937,1.5252830188679245,1.8316109422492401,2.1181176470588237,2.311531190926276]
[null,null,"% of Total Bill",0.49943220531455823,0.39207874384813685,0.34194685068271913,0.31192919687411735,0.2968850625360133]
[]
[null,null,"Retail Transmission"]
[null,null,"Applied For Bill",2.85,6.85,11.41,18.25,25.66]
[null,null,"Current Bill",2.85,6.85,11.41,18.25,25.66]
[null,null,"$ Impact",0,0,0,0,0]
[null,null,"% Impact",0,0,0,0,0]
[null,null,"% of Total Bill",0.06472859414035885,0.08026716662760722,0.08376156217882837,0.08591469729780624,0.08697420601294785]
[]
[null,null,"Delivery (Distribution and Retail Transmission)"]
[null,null,"Applied For Bill",24.84,40.31,57.99,84.51,113.25]
[null,null,"Current Bill",13.3,20.1,27.86,39.5,52.11]
[null,null,"$ Impact",11.54,20.21,30.130000000000003,45.010000000000005,61.14]
[null,null,"% Impact",0.8676691729323307,1.0054726368159204,1.0814788226848528,1.1394936708860761,1.17328727691422]
[null,null,"% of Total Bill",0.564160799454917,0.4723459104757441,0.42570841286154754,0.3978438941719236,0.3838592685489612]
[]
[null,null,"Regulatory"]
[null,null,"Applied For Bill",1.99,4.41,7.19,11.34,15.84]
[null,null,"Current Bill",1.91,4.22,6.87,10.83,15.12]
[null,null,"$ Impact",0.08000000000000007,0.1900000000000004,0.3200000000000003,0.5099999999999998,0.7200000000000006]
[null,null,"% Impact",0.04188481675392674,0.04502369668246455,0.046579330422125226,0.04709141274238225,0.047619047619047665]
[null,null,"% of Total Bill",0.04519645696116284,0.0516756503398172,0.052782263984730585,0.053384803690801244,0.053689455309629534]
[]
[null,null,"Debt Retirement Charge"]
[null,null,"Applied For Bill",1.75,4.2,7,11.2,15.75]
[null,null,"Current Bill",1.75,4.2,7,11.2,15.75]
[null,null,"$ Impact",0,0,0,0,0]
[null,null,"% Impact",0,0,0,0,0]
[null,null,"% of Total Bill",0.0397456279809221,0.04921490508554019,0.051387461459403906,0.05272573204029753,0.05338440158627936]
[]
[null,null,"GST"]
[null,null,"Applied For Bill",2.1,4.06,6.49,10.12,14.05]
[null,null,"Current Bill",1.52,3.04,4.96,7.84,10.96]
[null,null,"$ Impact",0.5800000000000001,1.0199999999999996,1.5300000000000002,2.2799999999999994,3.09]
[null,null,"% Impact",0.3815789473684211,0.33552631578947356,0.30846774193548393,0.2908163265306122,0.28193430656934304]
[null,null,"% of Total Bill",0.04769475357710652,0.047574408249355514,0.04764351783879019,0.047641465022125976,0.0476222757007762]
[]
[null,null,"Total Bill"]
[null,null,"Applied For Bill",44.03,85.34,136.22,212.42,295.03]
[null,null,"Current Bill",31.83,63.92,104.24,164.62,230.08]
[null,null,"$ Impact",12.200000000000003,21.42,31.980000000000004,47.79999999999998,64.94999999999996]

{"sheet":"General Service Less Than 50 kW","index":1,"n_rows":119,"n_cols":12,"rows_kept":119,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
{"$rows_empty":19}
[null,null,"General Service Less Than 50 kW"]
[]
[null,null,"Monthly Rates and Charges","Metric","Current Rate","Applied For Rate"]
[null,null,"Service Charge","$",17.26,27.1]
[null,null,"Service Charge Rate Rider(s)","$",0,0]
[null,null,"Distribution Volumetric Rate","$/kWh",0.0038,0.007]
[null,null,"Distribution Volumetric Rate Rider(s)","$/kWh",0,0.0192]
[null,null,"Retail Transmission Rate – Network Service Rate","$/kWh",0.0052,0.0052]
[null,null,"Retail Transmission Rate – Line and Transformation Connection Service Rate","$/kWh",0.0045,0.0045]
[null,null,"Wholesale Market Service Rate ","$/kWh",0.005200000014156103,0.0052]
[null,null,"Rural Rate Protection Charge","$/kWh",0.0010000000474974513,0.0013]
[null,null,"Standard Supply Service – Administration Charge (if applicable)","$",0.25,0.25]
[]
[null,null,"Consumption",10000,"kWh",0,"kW",null,"Current Loss Factor",1.0662]
[null,null,"RPP Tier One",750,"kWh","Load Factor","",null,"Proposed Loss Factor",1.0662]
[]
[null,null,null,"Volume","RATE                             $","CHARGE\n$","Volume","RATE                             $","CHARGE\n$","$","%","% of Total Bill"]
[null,null,"Energy First Tier (kWh)",750,0.05,37.5,750,0.05,37.5,0,0,0.030935999604019205]
[null,null,"Energy Second Tier (kWh)",9913,0.059,584.87,9913,0.059,584.87,0,0,0.4824943490240723]
[null,null,"Sub-Total:  Energy",null,null,622.37,null,null,622.37,0,0,0.5134303486280916]
[null,null,"Service Charge",1,17.26,17.26,1,27.1,27.1,9.84,0.5701042873696407,0.02235641571383788]
[null,null,"Service Charge Rate Rider(s)",1,0,0,1,0,0,0,0,0]
[null,null,"Distribution Volumetric Rate",10000,0.0038,38,10000,0.007,70,32,0.8421052631578947,0.057747199260835845]
[null,null,"Distribution Volumetric Rate Rider(s)",10000,0,0,10000,0.0192,192,192,0,0.15839231797257833]
[null,null,"Total:  Distribution",null,null,55.260000000000005,null,null,289.1,233.84,4.231632283749548,0.23849593294725208]
[null,null,"Retail Transmission Rate – Network Service Rate",10663,0.0052,55.45,10663,0.0052,55.45,0,0,0.045744031414476395]
[null,null,"Retail Transmission Rate – Line and Transformation Connection Service Rate",10663,0.0045,47.98,10663,0.0045,47.98,0,0,0.03958158029335577]
[null,null,"Total:    Retail Transmission",null,null,103.43,null,null,103.43,0,0,0.08532561170783218]
[null,null,"Sub-Total:  Delivery (Distribution and Retail Transmission)",null,null,158.69,null,null,392.53000000000003,233.84,1.47356481189741,0.3238215446550842]
[null,null,"Wholesale Market Service Rate ",10663,0.0052,55.45,10663,0.0052,55.45,0,0,0.045744031414476395]
[null,null,"Rural Rate Protection Charge",10663,0.001,10.66,10663,0.0013,13.86,3.1999999999999993,0.3001876172607879,0.011433945453645497]
[null,null,"Standard Supply Service – Administration Charge (if applicable)",1,0.25,0.25,1,0.25,0.25,0,0,0.000206239997360128]
[null,null,"Sub-Total:  Regulatory",null,null,66.36,null,null,69.56,3.1999999999999993,0.048221820373719096,0.05738421686548202]
[null,null,"Debt Retirement Charge (DRC)",10000,0.00700000021606684,70,10000,0.00700000021606684,70,0,0,0.057747199260835845]
[null,null,"Total Bill before Taxes",null,null,917.42,null,null,1154.46,237.04000000000008,0.2583767521963769,0.9523833094094937]
[null,null,"GST",917.42,0.05,45.87,1154.46,0.05,57.72,11.850000000000001,0.2583387835186397,0.047616690590506355]
[{"$nulls":5},963.29,null,null,1212.18,248.8900000000001,0.2583749442016424,1]
[]
[]
[]
[null,null,"Rate Class Threshold Test"]
[null,null,"General Service Less Than 50 kW"]
[null,null,"kWh",1000,5000,10000,15000,20000]
[null,null,"Loss Factor Adjusted kWh",1067,5332,10663,15994,21325]
[null,null,"kW"]
[null,null,"Load Factor","","","","",""]
[]
[null,null,"Energy"]
[null,null,"Applied For Bill",56.2,307.84,622.37,936.9,1251.43]
[null,null,"Current Bill",56.2,307.84,622.37,936.9,1251.43]
[null,null,"$ Impact",0,0,0,0,0]
[null,null,"% Impact",0,0,0,0,0]
[null,null,"% of Total Bill",0.3993178911467956,0.4989707431720561,0.5134303486280916,0.518363191731861,0.5208540569787526]
[]
[null,null,"Distribution"]
[null,null,"Applied For Bill",53.3,158.1,289.1,420.1,551.1]
[null,null,"Current Bill",21.06,36.26,55.26,74.26,93.26]
[null,null,"$ Impact",32.239999999999995,121.84,233.84000000000003,345.84000000000003,457.84000000000003]
[null,null,"% Impact",1.5308641975308641,3.3601765030336463,4.231632283749549,4.657150552114193,4.909285867467296]
[null,null,"% of Total Bill",0.3787125195395766,0.25626063700461954,0.23849593294725208,0.23243075765455737,0.22937173537552286]
[]
[null,null,"Retail Transmission"]
[null,null,"Applied For Bill",10.35,51.72,103.43,155.14,206.85]
[null,null,"Current Bill",10.35,51.72,103.43,155.14,206.85]
[null,null,"$ Impact",0,0,0,0,0]
[null,null,"% Impact",0,0,0,0,0]
[null,null,"% of Total Bill",0.07353986073610914,0.0838317529783613,0.08532561170783218,0.08583505770656516,0.08609243959794394]
[]
[null,null,"Delivery (Distribution and Retail Transmission)"]
[null,null,"Applied For Bill",63.65,209.82,392.53,575.24,757.95]
[null,null,"Current Bill",31.41,87.98,158.69,229.4,300.11]
[null,null,"$ Impact",32.239999999999995,121.83999999999999,233.83999999999997,345.84000000000003,457.84000000000003]
[null,null,"% Impact",1.0264247055078,1.3848601954989768,1.4735648118974098,1.507585004359198,1.5255739562160542]
[null,null,"% of Total Bill",0.4522523802756857,0.3400923899829808,0.32382154465508417,0.31826581536112253,0.3154641749734668]
[]
[null,null,"Regulatory"]
[null,null,"Applied For Bill",7.19,34.91,69.56,104.21,138.86]
[null,null,"Current Bill",6.87,33.31,66.36,99.41,132.47]
[null,null,"$ Impact",0.3200000000000003,1.5999999999999943,3.200000000000003,4.799999999999997,6.390000000000015]
[null,null,"% Impact",0.046579330422125226,0.04803362353647536,0.04822182037371915,0.048284880796700506,0.048237336755491925]
[null,null,"% of Total Bill",0.05108711098479467,0.05658481238349947,0.05738421686548202,0.05765677042414049,0.057794518552431694]
[]
[null,null,"Debt Retirement Charge"]
[null,null,"Applied For Bill",7,35,70,105,140]
[null,null,"Current Bill",7,35,70,105,140]
[null,null,"$ Impact",0,0,0,0,0]
[null,null,"% Impact",0,0,0,0,0]
[null,null,"% of Total Bill",0.04973710387949411,0.05673069130399547,0.057747199260835845,0.058093857542795814,0.0582689946517387]
[]
[null,null,"GST"]
[null,null,"Applied For Bill",6.7,29.38,57.72,86.07,114.41]
[null,null,"Current Bill",5.07,23.21,45.87,68.54,91.2]
[null,null,"$ Impact",1.63,6.169999999999998,11.850000000000001,17.529999999999987,23.209999999999994]
[null,null,"% Impact",0.3214990138067061,0.26583369237397664,0.2583387835186397,0.2557630580682811,0.25449561403508764]
[null,null,"% of Total Bill",0.047605513713230074,0.04762136315746819,0.047616690590506355,0.04762036494008034,0.04761825484361018]
[]
[null,null,"Total Bill"]
[null,null,"Applied For Bill",140.73999999999998,616.9499999999999,1212.18,1807.4199999999998,2402.65]
[null,null,"Current Bill",106.55000000000001,487.34,963.29,1439.25,1915.21]
[null,null,"$ Impact",34.18999999999997,129.60999999999996,248.8900000000001,368.16999999999985,487.44000000000005]

{"sheet":"Sentinel Lighting","index":2,"n_rows":119,"n_cols":12,"rows_kept":119,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
{"$rows_empty":19}
[null,null,"Sentinel Lighting"]
[]
[null,null,"Monthly Rates and Charges","Metric","Current Rate","Applied For Rate"]
[null,null,"Service Charge","$",0.62,0.94]
[null,null,"Service Charge Rate Rider(s)","$",0,0]
[null,null,"Distribution Volumetric Rate","$/kW",3.2841,5.4335]
[null,null,"Distribution Volumetric Rate Rider(s)","$/kW",0,18.0498]
[null,null,"Retail Transmission Rate – Network Service Rate","$/kW",1.4113,1.4113]
[null,null,"Retail Transmission Rate – Line and Transformation Connection Service Rate","$/kW",1.6083,1.6083]
[null,null,"Wholesale Market Service Rate ","$/kWh",0.005200000014156103,0.0052]
[null,null,"Rural Rate Protection Charge","$/kWh",0.0010000000474974513,0.0013]
[null,null,"Standard Supply Service – Administration Charge (if applicable)","$",0.25,0.25]
[]
[null,null,"Consumption",180,"kWh",0.5,"kW",null,"Current Loss Factor",1.0662]
[null,null,"RPP Tier One",750,"kWh","Load Factor",0.493421052631579,null,"Proposed Loss Factor",1.0662]
[]
[null,null,null,"Volume","RATE                             $","CHARGE\n$","Volume","RATE                             $","CHARGE\n$","$","%","% of Total Bill"]
[null,null,"Energy First Tier (kWh)",192,0.05,9.6,192,0.05,9.6,0,0,0.22972002871500358]
[null,null,"Energy Second Tier (kWh)",0,0.059,0,0,0.059,0,0,0,0]
[null,null,"Sub-Total:  Energy",null,null,9.6,null,null,9.6,0,0,0.22972002871500358]
[null,null,"Service Charge",1,0.62,0.62,1,0.94,0.94,0.31999999999999995,0.5161290322580644,0.0224934194783441]
[null,null,"Service Charge Rate Rider(s)",1,0,0,1,0,0,0,0,0]
[null,null,"Distribution Volumetric Rate",1,3.2841,3.28,1,5.4335,5.43,2.15,0.6554878048780488,0.1299353912419239]
[null,null,"Distribution Volumetric Rate Rider(s)",1,0,0,1,18.0498,18.05,18.05,0,0.4319215123235224]
[null,null,"Total:  Distribution",null,null,3.9,null,null,24.42,20.52,5.2615384615384615,0.5843503230437904]
[null,null,"Retail Transmission Rate – Network Service Rate",1,1.4113,1.41,1,1.4113,1.41,0,0,0.03374012921751615]
[null,null,"Retail Transmission Rate – Line and Transformation Connection Service Rate",1,1.6083,1.61,1,1.6083,1.61,0,0,0.03852596314907873]
[null,null,"Total:    Retail Transmission",null,null,3.02,null,null,3.02,0,0,0.07226609236659488]
[null,null,"Sub-Total:  Delivery (Distribution and Retail Transmission)",null,null,6.92,null,null,27.44,20.52,2.9653179190751446,0.6566164154103853]
[null,null,"Wholesale Market Service Rate ",192,0.0052,1,192,0.0052,1,0,0,0.023929169657812874]
[null,null,"Rural Rate Protection Charge",192,0.001,0.19,192,0.0013,0.25,0.06,0.3157894736842105,0.0059822924144532184]
[null,null,"Standard Supply Service – Administration Charge (if applicable)",1,0.25,0.25,1,0.25,0.25,0,0,0.0059822924144532184]
[null,null,"Sub-Total:  Regulatory",null,null,1.44,null,null,1.5,0.06,0.041666666666666664,0.03589375448671931]
[null,null,"Debt Retirement Charge (DRC)",180,0.00700000021606684,1.26,180,0.00700000021606684,1.26,0,0,0.030150753768844223]
[null,null,"Total Bill before Taxes",null,null,19.220000000000002,null,null,39.8,20.579999999999995,1.070759625390218,0.9523809523809523]
[null,null,"GST",19.22,0.05,0.96,39.8,0.05,1.99,1.03,1.0729166666666667,0.047619047619047616]
[{"$nulls":5},20.180000000000003,null,null,41.79,21.609999999999996,1.0708622398414267,1]
[]
[]
[]
[null,null,"Rate Class Threshold Test"]
[null,null,"Sentinel Lighting"]
[null,null,"kWh",70,130,180,270,360]
[null,null,"Loss Factor Adjusted kWh",75,139,192,288,384]
[null,null,"kW",0.2,0.35,0.5,0.75,1]
[null,null,"Load Factor",0.4797149122807017,0.5090852130325816,0.493421052631579,0.493421052631579,0.493421052631579]
[]
[null,null,"Energy"]
[null,null,"Applied For Bill",3.75,6.95,9.6,14.4,19.2]
[null,null,"Current Bill",3.75,6.95,9.6,14.4,19.2]
[null,null,"$ Impact",0,0,0,0,0]
[null,null,"% Impact",0,0,0,0,0]
[null,null,"% of Total Bill",0.11016451233842539,0.18160438986151034,0.22972002871500358,0.29912754466140423,0.35222894881673084]
[]
[null,null,"Distribution"]
[null,null,"Applied For Bill",24.42,24.42,24.42,24.42,24.42]
[null,null,"Current Bill",3.9,3.9,3.9,3.9,3.9]
[null,null,"$ Impact",20.520000000000003,20.520000000000003,20.520000000000003,20.520000000000003,20.520000000000003]
[null,null,"% Impact",5.261538461538462,5.261538461538462,5.261538461538462,5.261538461538462,5.261538461538462]
[null,null,"% of Total Bill",0.7173913043478262,0.6380977266788609,0.5843503230437904,0.5072704611549648,0.4479911942762796]
[]
[null,null,"Retail Transmission"]
[null,null,"Applied For Bill",3.02,3.02,3.02,3.02,3.02]
[null,null,"Current Bill",3.02,3.02,3.02,3.02,3.02]
[null,null,"$ Impact",0,0,0,0,0]
[null,null,"% Impact",0,0,0,0,0]
[null,null,"% of Total Bill",0.08871915393654524,0.07891298667363471,0.07226609236659488,0.06273369339426672,0.05540267840763162]
[]
[null,null,"Delivery (Distribution and Retail Transmission)"]
[null,null,"Applied For Bill",27.44,27.44,27.44,27.44,27.44]
[null,null,"Current Bill",6.92,6.92,6.92,6.92,6.92]
[null,null,"$ Impact",20.520000000000003,20.520000000000003,20.520000000000003,20.520000000000003,20.520000000000003]
[null,null,"% Impact",2.965317919075145,2.965317919075145,2.965317919075145,2.965317919075145,2.965317919075145]
[null,null,"% of Total Bill",0.8061104582843713,0.7170107133524956,0.6566164154103853,0.5700041545492315,0.5033938726839112]
[]
[null,null,"Regulatory"]
[null,null,"Applied For Bill",0.74,1.15,1.5,2.12,2.75]
[null,null,"Current Bill",0.72,1.11,1.44,2.04,2.63]
[null,null,"$ Impact",0.020000000000000018,0.039999999999999813,0.06000000000000005,0.08000000000000007,0.1200000000000001]
[null,null,"% Impact",0.027777777777777804,0.03603603603603586,0.041666666666666706,0.03921568627450984,0.045627376425855556]
[null,null,"% of Total Bill",0.021739130434782608,0.030049647243271492,0.03589375448671931,0.04403822185292896,0.05044945881489635]
[]
[null,null,"Debt Retirement Charge"]
[null,null,"Applied For Bill",0.49,0.91,1.26,1.89,2.52]
[null,null,"Current Bill",0.49,0.91,1.26,1.89,2.52]
[null,null,"$ Impact",0,0,0,0,0]
[null,null,"% Impact",0,0,0,0,0]
[null,null,"% of Total Bill",0.014394829612220916,0.023778416514240924,0.030150753768844223,0.0392604902368093,0.04623004953219592]
[]
[null,null,"GST"]
[null,null,"Applied For Bill",1.62,1.82,1.99,2.29,2.6]
[null,null,"Current Bill",0.59,0.79,0.96,1.26,1.56]
[null,null,"$ Impact",1.0300000000000002,1.03,1.03,1.03,1.04]
[null,null,"% Impact",1.7457627118644072,1.3037974683544304,1.0729166666666667,0.8174603174603174,0.6666666666666666]
[null,null,"% of Total Bill",0.04759106933019977,0.04755683302848185,0.047619047619047616,0.04756958869962609,0.047697670152265635]
[]
[null,null,"Total Bill"]
[null,null,"Applied For Bill",34.04,38.269999999999996,41.79,48.14,54.510000000000005]
[null,null,"Current Bill",12.47,16.68,20.180000000000003,26.51,32.83]
[null,null,"$ Impact",21.57,21.589999999999996,21.609999999999996,21.63,21.680000000000007]

{"sheet":"Street Lighting","index":3,"n_rows":119,"n_cols":12,"rows_kept":119,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
{"$rows_empty":19}
[null,null,"Street Lighting"]
[]
[null,null,"Monthly Rates and Charges","Metric","Current Rate","Applied For Rate"]
[null,null,"Service Charge","$",0.42,0.63]
[null,null,"Service Charge Rate Rider(s)","$",0,0]
[null,null,"Distribution Volumetric Rate","$/kW",1.9467,3.3927]
[null,null,"Distribution Volumetric Rate Rider(s)","$/kW",0,7.676]
[null,null,"Retail Transmission Rate – Network Service Rate","$/kW",1.6002,1.6002]
[null,null,"Retail Transmission Rate – Line and Transformation Connection Service Rate","$/kW",1.3824,1.3824]
[null,null,"Wholesale Market Service Rate ","$/kWh",0.005200000014156103,0.0052]
[null,null,"Rural Rate Protection Charge","$/kWh",0.0010000000474974513,0.0013]
[null,null,"Standard Supply Service – Administration Charge (if applicable)","$",0.25,0.25]
[]
[null,null,"Consumption",180,"kWh",0.5,"kW",null,"Current Loss Factor",1.0662]
[null,null,"RPP Tier One",750,"kWh","Load Factor",0.493421052631579,null,"Proposed Loss Factor",1.0662]
[]
[null,null,null,"Volume","RATE                             $","CHARGE\n$","Volume","RATE                             $","CHARGE\n$","$","%","% of Total Bill"]
[null,null,"Energy First Tier (kWh)",192,0.05,9.6,192,0.05,9.6,0,0,0.33814723494188087]
[null,null,"Energy Second Tier (kWh)",0,0.059,0,0,0.059,0,0,0,0]
[null,null,"Sub-Total:  Energy",null,null,9.6,null,null,9.6,0,0,0.33814723494188087]
[null,null,"Service Charge",1,0.42,0.42,1,0.63,0.63,0.21000000000000002,0.5000000000000001,0.022190912293060933]
[null,null,"Service Charge Rate Rider(s)",1,0,0,1,0,0,0,0,0]
[null,null,"Distribution Volumetric Rate",1,1.9467,1.95,1,3.3927,3.39,1.4400000000000002,0.7384615384615386,0.1194082423388517]
[null,null,"Distribution Volumetric Rate Rider(s)",1,0,0,1,7.676,7.68,7.68,0,0.27051778795350473]
[null,null,"Total:  Distribution",null,null,2.37,null,null,11.7,9.33,3.9367088607594933,0.4121169425854173]
[null,null,"Retail Transmission Rate – Network Service Rate",1,1.6002,1.6,1,1.6002,1.6,0,0,0.05635787249031349]
[null,null,"Retail Transmission Rate – Line and Transformation Connection Service Rate",1,1.3824,1.38,1,1.3824,1.38,0,0,0.048608665022895375]
[null,null,"Total:    Retail Transmission",null,null,2.98,null,null,2.98,0,0,0.10496653751320886]
[null,null,"Sub-Total:  Delivery (Distribution and Retail Transmission)",null,null,5.35,null,null,14.68,9.33,1.7439252336448599,0.5170834800986261]
[null,null,"Wholesale Market Service Rate ",192,0.0052,1,192,0.0052,1,0,0,0.03522367030644593]
[null,null,"Rural Rate Protection Charge",192,0.001,0.19,192,0.0013,0.25,0.06,0.3157894736842105,0.008805917576611482]
[null,null,"Standard Supply Service – Administration Charge (if applicable)",1,0.25,0.25,1,0.25,0.25,0,0,0.008805917576611482]
[null,null,"Sub-Total:  Regulatory",null,null,1.44,null,null,1.5,0.06,0.041666666666666664,0.05283550545966889]
[null,null,"Debt Retirement Charge (DRC)",180,0.00700000021606684,1.26,180,0.00700000021606684,1.26,0,0,0.04438182458612187]
[null,null,"Total Bill before Taxes",null,null,17.650000000000002,null,null,27.040000000000003,9.39,0.5320113314447592,0.952448045086298]
[null,null,"GST",17.65,0.05,0.88,27.04,0.05,1.35,0.4700000000000001,0.5340909090909092,0.047551954913702]
[{"$nulls":5},18.53,null,null,28.390000000000004,9.860000000000003,0.5321100917431194,1]
[]
[]
[]
[null,null,"Rate Class Threshold Test"]
[null,null,"Street Lighting"]
[null,null,"kWh",70,130,180,270,360]
[null,null,"Loss Factor Adjusted kWh",75,139,192,288,384]
[null,null,"kW",0.2,0.35,0.5,0.75,1]
[null,null,"Load Factor",0.4797149122807017,0.5090852130325816,0.493421052631579,0.493421052631579,0.493421052631579]
[]
[null,null,"Energy"]
[null,null,"Applied For Bill",3.75,6.95,9.6,14.4,19.2]
[null,null,"Current Bill",3.75,6.95,9.6,14.4,19.2]
[null,null,"$ Impact",0,0,0,0,0]
[null,null,"% Impact",0,0,0,0,0]
[null,null,"% of Total Bill",0.18168604651162792,0.27945315641334945,0.33814723494188087,0.4145077720207255,0.4670396497202627]
[]
[null,null,"Distribution"]
[null,null,"Applied For Bill",11.7,11.7,11.7,11.7,11.7]
[null,null,"Current Bill",2.37,2.37,2.37,2.37,2.37]
[null,null,"$ Impact",9.329999999999998,9.329999999999998,9.329999999999998,9.329999999999998,9.329999999999998]
[null,null,"% Impact",3.936708860759493,3.936708860759493,3.936708860759493,3.936708860759493,3.936708860759493]
[null,null,"% of Total Bill",0.5668604651162791,0.4704463208685163,0.4121169425854173,0.3367875647668394,0.28460228654828507]
[]
[null,null,"Retail Transmission"]
[null,null,"Applied For Bill",2.98,2.98,2.98,2.98,2.98]
[null,null,"Current Bill",2.98,2.98,2.98,2.98,2.98]
[null,null,"$ Impact",0,0,0,0,0]
[null,null,"% Impact",0,0,0,0,0]
[null,null,"% of Total Bill",0.14437984496124032,0.11982308001608365,0.10496653751320886,0.08578008059873346,0.07248844563366577]
[]
[null,null,"Delivery (Distribution and Retail Transmission)"]
[null,null,"Applied For Bill",14.68,14.68,14.68,14.68,14.68]
[null,null,"Current Bill",5.35,5.35,5.35,5.35,5.35]
[null,null,"$ Impact",9.33,9.33,9.33,9.33,9.33]
[null,null,"% Impact",1.7439252336448599,1.7439252336448599,1.7439252336448599,1.7439252336448599,1.7439252336448599]
[null,null,"% of Total Bill",0.7112403100775194,0.5902694008846,0.5170834800986261,0.4225676453655729,0.35709073218195087]
[]
[null,null,"Regulatory"]
[null,null,"Applied For Bill",0.74,1.15,1.5,2.12,2.75]
[null,null,"Current Bill",0.72,1.11,1.44,2.04,2.63]
[null,null,"$ Impact",0.020000000000000018,0.039999999999999813,0.06000000000000005,0.08000000000000007,0.1200000000000001]
[null,null,"% Impact",0.027777777777777804,0.03603603603603586,0.041666666666666706,0.03921568627450984,0.045627376425855556]
[null,null,"% of Total Bill",0.03585271317829458,0.04624045034177724,0.05283550545966889,0.061024755325273475,0.06689369982972512]
[]
[null,null,"Debt Retirement Charge"]
[null,null,"Applied For Bill",0.49,0.91,1.26,1.89,2.52]
[null,null,"Current Bill",0.49,0.91,1.26,1.89,2.52]
[null,null,"$ Impact",0,0,0,0,0]
[null,null,"% Impact",0,0,0,0,0]
[null,null,"% of Total Bill",0.023740310077519384,0.036590269400884605,0.04438182458612187,0.05440414507772021,0.06129895402578448]
[]
[null,null,"GST"]
[null,null,"Applied For Bill",0.98,1.18,1.35,1.65,1.96]
[null,null,"Current Bill",0.52,0.72,0.88,1.18,1.49]
[null,null,"$ Impact",0.45999999999999996,0.45999999999999996,0.4700000000000001,0.47,0.47]
[null,null,"% Impact",0.8846153846153845,0.6388888888888888,0.5340909090909092,0.3983050847457627,0.31543624161073824]
[null,null,"% of Total Bill",0.04748062015503877,0.04744672295938882,0.047551954913702,0.04749568221070812,0.04767696424227682]
[]
[null,null,"Total Bill"]
[null,null,"Applied For Bill",20.639999999999997,24.869999999999997,28.390000000000004,34.739999999999995,41.11]
[null,null,"Current Bill",10.83,15.040000000000001,18.53,24.86,31.189999999999994]
[null,null,"$ Impact",9.809999999999997,9.829999999999997,9.860000000000003,9.879999999999995,9.920000000000005]